package com.example.jpademo.db.entity;

import lombok.Data;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;

/**
 * 白名单统计表-按交易员-按发行人
 */
@Data
@Entity
@Table(name = "stats_agent_whitelist")
public class StatsAgentWhitelist implements Serializable {

    private static final long serialVersionUID = 1L;

    @Id
    @Column(name = "id", nullable = false)
    private String id;

    /**
     * 机构id
     */
    @Column(name = "bank_id")
    private String bankId;

    /**
     * 交易员id
     */
    @Column(name = "agent_id")
    private String agentId;

    /**
     * 发行人机构code
     */
    @Column(name = "issuer_code")
    private String issuerCode;

    /**
     * 券类型:BCO/BNC/ABS/NCD
     */
    @Column(name = "bond_category")
    private String bondCategory;

    /**
     * 成交笔数
     */
    @Column(name = "total_trade")
    private BigDecimal totalTrade;

    /**
     * 报价次数
     */
    @Column(name = "total_quote")
    private BigDecimal totalQuote;

    /**
     * 统计起始日期
     */
    @Column(name = "stats_begin_date")
    private Date statsBeginDate;

    /**
     * 统计结束日期
     */
    @Column(name = "stats_end_date")
    private Date statsEndDate;

    /**
     * 创建时间
     */
    @Column(name = "create_time")
    private Date createTime;

    /**
     * 1-有效；2-无效
     */
    @Column(name = "status")
    private String status;

}
